From: <Saved by Windows Internet Explorer 7>
Subject: MySQL Database access problem in Ruby on Rails
Date: Sun, 4 May 2008 11:00:37 +0200
MIME-Version: 1.0
Content-Type: multipart/related;
	type="text/html";
	boundary="----=_NextPart_000_0000_01C8ADD6.156E35D0"
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C8ADD6.156E35D0
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Location: http://wiki.rubyonrails.org/rails/pages/MySQL+Database+access+problem

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" =
"http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns=3D"http://www.w3.org/1999/xhtml"><HEAD><TITLE>MySQL Database =
access problem in Ruby on Rails</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3DUTF-8"><LINK title=3DRSS=20
href=3D"http://wiki.rubyonrails.org/rails/feed.rss" =
type=3Dapplication/rss+xml=20
rel=3Dalternate>
<STYLE type=3Dtext/css>H1#pageName {
	COLOR: #393
}
.newWikiWord A {
	COLOR: #393
}
A.existingWikiWord {
	COLOR: #393
}
.newWikiWord A:hover {
	COLOR: #393
}
#TextileHelp H3 {
	COLOR: #393
}
#Container {
	WIDTH: 600px
}
#Content {
	WIDTH: 600px
}
</STYLE>
<LINK media=3Dscreen=20
href=3D"http://wiki.rubyonrails.org/stylesheets/instiki.css?1171099937"=20
type=3Dtext/css rel=3DStylesheet><LINK media=3Dscreen=20
href=3D"http://wiki.rubyonrails.org/stylesheets/captcha.css?1171099937"=20
type=3Dtext/css rel=3DStylesheet>
<STYLE type=3Dtext/css></STYLE>

<META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR></HEAD>
<BODY>
<DIV id=3DContainer>
<DIV id=3DHeader>
<DIV id=3DNav><IMG height=3D16 alt=3DFavicon=20
src=3D"http://wiki.rubyonrails.org/images/favicon.png?1171099937" =
width=3D16> <A=20
href=3D"http://www.rubyonrails.org/">Ruby on Rails</A> | <A=20
href=3D"http://www.rubyonrails.org/screencasts">Screencasts</A> | <A=20
href=3D"http://www.rubyonrails.org/down">Download</A> | <A=20
href=3D"http://www.rubyonrails.org/docs">Documentation</A> | <A=20
href=3D"http://weblog.rubyonrails.org/">Weblog</A> | <A class=3Dcurrent=20
href=3D"http://www.rubyonrails.org/community">Community</A> | <A=20
href=3D"http://dev.rubyonrails.org/">Source</A> </DIV></DIV>
<DIV id=3DContent>
<DIV id=3Di2Nav>
<H1 id=3DpageName><SMALL>Ruby on Rails</SMALL><BR>MySQL Database access=20
problem</H1>
<FORM class=3Dnavigation id=3DnavigationForm><A=20
href=3D"http://wiki.rubyonrails.org/rails">Home Page</A> | <A=20
href=3D"http://wiki.rubyonrails.org/rails/pages">All Pages</A> | <A=20
href=3D"http://wiki.rubyonrails.org/rails/recent">Recently Revised</A> | =
<A=20
href=3D"http://wiki.rubyonrails.org/rails/feed.rss">Feed</A> =
</FORM></DIV>
<H2>Symptoms</H2>
<H3>Rails can=E2=80=99t query MySQL at all.</H3>
<P>Looking in the log(such as /log/development.log) you see errors such=20
as:</P><CODE><PRE>ActiveRecord::StatementInvalid in  Recipe#new
Packets out of order: 1&lt;&gt;3: SHOW FIELDS FROM recipes
</PRE></CODE>
<H4>possible solution</H4>
<BLOCKQUOTE>
  <P>MySql version 4.1.x introduced a new password hashing mechanism =
that is=20
  incompatible with the previously used scheme. This gave me a headache, =
when I=20
  tried connecting to my local MySQL using <A class=3DexistingWikiWord=20
  =
href=3D"http://wiki.rubyonrails.org/rails/pages/CocoaMySQL">CocoaMySQL</A=
>,=20
  since it doesn=E2=80=99t know the new scheme.</P></BLOCKQUOTE>
<BLOCKQUOTE>
  <P>I found a hint that setting a password in MySQL with the hashing =
function=20
  <CODE>OLD_PASSWORD('_thePass_')</CODE> solves the issue. Did that, =
connect=20
  worked (use <CODE>FLUSH PRIVILEGES;</CODE> after changes to user=20
accounts).</P></BLOCKQUOTE>
<BLOCKQUOTE>
  <P>When I tried to get started with Rails, the above errors showed up. =
So I=20
  learned that Rails 0.10.1 (which I am using) know=E2=80=99s about the =
new scheme and=20
  that is incompatible with my oldstyle pass. So I ended up setting two =
user=20
  acccounts, one for admin with oldstyle, one for rails with new or =
normalstyle.=20
  Again: <CODE>FLUSH PRIVILEGES; </CODE>;-)</P></BLOCKQUOTE>
<H4>possible solution</H4>
<BLOCKQUOTE>
  <P>Alternatively, you could use the new version of <A =
class=3DexistingWikiWord=20
  =
href=3D"http://wiki.rubyonrails.org/rails/pages/CocoaMySQL">CocoaMySQL</A=
>=20
  available from &lt;<A=20
  =
href=3D"http://www.theonline.org/cocoamysql/">http://www.theonline.org/co=
coamysql/</A>&gt;.=20
  This copes with the new password mechanism of \MySQL 4.1.x. =
=E2=80=94<A=20
  class=3DexistingWikiWord=20
  =
href=3D"http://wiki.rubyonrails.org/rails/pages/AlisdairMcDiarmid">Alisda=
irMcDiarmid</A></P></BLOCKQUOTE>
<H4>possible solution</H4>
<BLOCKQUOTE>
  <P>Quick fix suggestion=E2=80=94create a local mysql user account for =
your rails app=20
  with <SPAN class=3Dcaps>NO PASSWORD</SPAN>. Worked for me. =
-Obie</P></BLOCKQUOTE>
<H4>possible solution</H4>
<BLOCKQUOTE>
  <P>The above method did not work for me (tried both forms of hashing) =
but=20
  Fullmoon on <A class=3DexistingWikiWord=20
  href=3D"http://wiki.rubyonrails.org/rails/pages/IRC">#rubyonrails</A> =
suggested=20
  this:</P></BLOCKQUOTE>
<BLOCKQUOTE>
  <P>Commennting out =E2=80=9Crequire =
=E2=80=98active_record/vendor/mysql411=E2=80=99=E2=80=9D in=20
  =
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.9.1/lib/active_record/co=
nnection_adapters/mysql_adapter.rb=20
  helped with my packet out of order error (with mySQL on=20
windows)</P></BLOCKQUOTE>
<BLOCKQUOTE>
  <P>This also worked for me on an old Redhat 7 box I had just upgraded =
to Rails=20
  0.11.1.</P></BLOCKQUOTE>
<BLOCKQUOTE>
  <P>=E2=80=94<SPAN class=3DnewWikiWord>Peter Cooper<A=20
  =
href=3D"http://wiki.rubyonrails.org/rails/pages/Peter+Cooper">?</A></SPAN=
></P></BLOCKQUOTE>
<H4>possible solution</H4>
<BLOCKQUOTE>
  <P>This error also occurs when using =E2=80=98standard=E2=80=99 Rails =
\MySQL driver with=20
  \MySQL 4.1x. To solve it you can build the binary \MySQL extension =
(&lt;<A=20
  =
href=3D"http://www.tmtm.org/en/mysql/ruby/">http://www.tmtm.org/en/mysql/=
ruby/</A>&gt;)=20
  against the new \MySQL 4.1 libraries =E2=80=93 Rails will use this =
extensioln and you=20
  will no longer experience the error=E2=80=94<A =
class=3DexistingWikiWord=20
  href=3D"http://wiki.rubyonrails.org/rails/pages/Julik+Tarkhanov">Julik =

  Tarkhanov</A></P></BLOCKQUOTE>
<H4>possible solution</H4>
<P>Apparently if you=E2=80=99re not using the old style password, this =
is all you=20
need:</P><PRE><CODE>gem install mysql</CODE></PRE>
<H3>Invalid Argument: <SPAN class=3Dcaps>SELECT</SPAN> <ACRONYM=20
title=3D"<strong>">COUNT</ACRONYM> <SPAN class=3Dcaps>FROM</SPAN> table =
(Win \MySQL=20
4.1)</H3>
<P>This error occurs when \MySQL 4.1 is run with <EM>old_passwords</EM>=20
directive to be compatible with <SPAN class=3Dcaps>PHP 4</SPAN>.</P>
<P>This problem was posted on rails mailing list but no solution was=20
provided.</P>
<H4>possible solution</H4>
<BLOCKQUOTE>
  <P>Quick and dirty solution:</P></BLOCKQUOTE>
<OL>
  <LI>comment out <EM>old_passwords</EM> directive in <EM>my.ini</EM>=20
  <LI>create new user (users created earlier won=E2=80=99t work) and use =
this in rails=20
  <LI>uncomment <EM>old_passwords</EM> directive in <EM>my.ini</EM> =
</LI></OL>
<H4>possible solution</H4>
<P>I now recommend the <CODE>gem install mysql</CODE> solution mentioned =
above.=20
It seems to have significantly increased the speed of database access =
compared=20
to whatever it was using before. =E2=80=94<SPAN =
class=3DnewWikiWord>Peter Cooper<A=20
href=3D"http://wiki.rubyonrails.org/rails/pages/Peter+Cooper">?</A></SPAN=
></P>
<H3>=E2=80=9Cgem install mysql=E2=80=9D problems</H3><PRE>imac:/ root# =
gem install mysql
Attempting local installation of 'mysql'
Local gem file not found: mysql*.gem
Attempting remote installation of 'mysql'
Updating Gem source index for: &lt;a =
href=3D"http://gems.rubyforge.org"&gt;http://gems.rubyforge.org&lt;/a&gt;=

Building native extensions.  This could take a while...
ERROR:  While executing gem ... (RuntimeError)
    ERROR: Failed to build gem native extension.
Gem files will remain installed in =
/usr/lib/ruby/gems/1.8/gems/mysql-2.5.1 for inspection.
  ruby extconf.rb install mysql\nchecking for mysql_query() in =
-lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... no
checking for mysql_query() in -lmysqlclient... no
</PRE>
<H4>Cause</H4>
<P>The reason this occurs is the install script cannot find your mysql =
library.=20
You either do not have installed or you do not have it in a standard=20
location.</P>
<H4>Solution</H4>
<UL>
  <LI>Install the MySQL client and libraries.=20
  <LI>Give gem the path to your MySQL installation by doing: =
</LI></UL><PRE>gem install mysql -- =
--with-mysql-config=3D/path/to/your/mysql/bin/mysql_config
</PRE>
<P>Most commonly, this is `/usr/local/mysql/bin/mysql_config` when this =
problem=20
occurs, so the command you should use is:</P><PRE>gem install mysql -- =
--with-mysql-config=3D/usr/local/mysql/bin/mysql_config
</PRE>
<H4>possible solution (FC4)</H4>
<BLOCKQUOTE>
  <P>make sure you have the following packages:</P></BLOCKQUOTE>
<UL>
  <LI>mysql-devel=20
  <LI>irb=20
  <LI>rdoc=20
  <LI>ruby-devel=20
  <LI>ruby-mysql gcc </LI></UL>
<BLOCKQUOTE>
  <P>after running =E2=80=9Cgem install mysql=E2=80=9D the first =
time</P></BLOCKQUOTE><PRE>cd /usr/lib/ruby/gems/1.8/gems/mysql-2.7
sudo ruby extconf.rb --with-mysql-lib=3D/usr/lib/mysql
sudo gem install mysql
</PRE>
<BLOCKQUOTE>
  <P>Replace the directory accordingly, the first one is where you gems =
are. The=20
  second directory is where you mysql libraries are.</P></BLOCKQUOTE>
<BLOCKQUOTE>
  <P><A=20
  =
href=3D"http://mopyblue.blogspot.com/2006/04/ruby-on-rail-fc4.html">http:=
//mopyblue.blogspot.com/2006/04/ruby-on-rail-fc4.html</A></P></BLOCKQUOTE=
>
<H4>possible solution (debian etch)</H4>
<BLOCKQUOTE>
  <P>sudo apt-get install libmysqlclient-dev</P></BLOCKQUOTE>
<H4>possible solution (kubuntu dapper drake)</H4>
<BLOCKQUOTE>
  <P>sudo apt-get install libmysql-ruby</P></BLOCKQUOTE>
<H4>possible solution (Mac <SPAN class=3Dcaps>OS X </SPAN>Tiger =
10.4.3)</H4>
<BLOCKQUOTE>
  <P>Worked for me on </STRONG><BR>bq. cd=20
  /usr/lib/ruby/gems/1.8/gems/mysql-2.7<BR>bq. sudo ruby=20
  extconf.rb=E2=80=94with-mysql-config<BR>bq. <A=20
  =
href=3D"http://wiki.rubyonrails.com/rails/show/HowtoInstallOnOSXTiger">ht=
tp://wiki.rubyonrails.com/rails/show/HowtoInstallOnOSXTiger</A></P></BLOC=
KQUOTE>
<H4>possible solution (Cygwin)</H4>
<BLOCKQUOTE>
  <P>Under Cygwin, this means installing MySQL from source ; you =
don=E2=80=99t have to=20
  run MySQL from under Cygwin but you do need it installed. Also, you =
need to=20
  install the full server (installing with =
<TT>./configure=E2=80=94without-server</TT>=20
  does not work)</P></BLOCKQUOTE>
<BLOCKQUOTE>
  <P>Native Win32 users need to make sure their Ruby installer has MySQL =
support=20
  built in or set up their build environment so Ruby can compile against =
the=20
  MySQL client libraries.</P></BLOCKQUOTE>
<H4>possible solution</H4><PRE>export PATH=3D/path/to/mysql/bin:$PATH
gem install mysql
</PRE>
<HR>
<BR>
<HR>
<BR>The =E2=80=9Cgem install mysql=E2=80=9D fix did not work for me. I =
have also tried changing=20
<A class=3DexistingWikiWord=20
href=3D"http://wiki.rubyonrails.org/rails/pages/MySQL">MySQL</A> setup =
to not=20
require passwords for the database in question. I have puts statements =
in=20
mysql_adapter.rb and mysql411.rb and they show that user name and =
database name=20
are being read in properly from database.yml. Error now is =
=E2=80=9C<CODE>No database=20
selected: SELECT COUNT(*) FROM picklists</CODE>=E2=80=9D (where =
picklists is the correct=20
table in my database. I=E2=80=99m running what I hope are current =
versions: \MacOS=20
10.4.1, \MySQL 4.1.12-max, ruby 1.8.2, Rails as of last week.<BR>
<HR>
<BR>I=E2=80=99m getting the same =E2=80=9C<CODE>No database =
selected</CODE>=E2=80=9D error. Did you get=20
the <A class=3DexistingWikiWord=20
href=3D"http://wiki.rubyonrails.org/rails/pages/MySQL">MySQL</A> API to =
install? I=20
get an error when compiling the <SPAN class=3Dcaps>API</SPAN> so I can =
never run=20
the makefile. I=E2=80=99m running the same versions: \MacOS 10.4.1, =
\MySQL 4.1.12-max,=20
ruby 1.8.2. Anyone have any luck with the <SPAN class=3Dcaps>API</SPAN>=20
installation?=20
<HR>

<P>What I see now is that if I try to use a \MySQL account that has a =
password,=20
I get this response as before:</P><PRE>Mysql::Error in Picklist#list
Access denied for user: 'acct2@localhost' (Using password: YES)
script/server:48
</PRE>
<P>My debug printout shows that the right information from database.yml =
is being=20
used.</P>
<P>Under the same setup, using a \MySQL account with no password for the =
same=20
database as before gets this response:</P><PRE>&lt;a =
href=3D"http://wiki.rubyonrails.org/rails/pages/NoMethodError" =
class=3D"existingWikiWord"&gt;NoMethodError&lt;/a&gt; in Picklist#list
undefined method `fetch_fields' for nil:NilClass
script/server:48
</PRE>
<HR>
<BR>For the above =E2=80=9Cundefined method=E2=80=9D error, installing =
the package from <A=20
href=3D"http://www.tmtm.org/en/mysql/ruby/">http://www.tmtm.org/en/mysql/=
ruby/</A>=20
fixed it for me.<BR>(a tip from <A=20
href=3D"http://wiki.rubyonrails.com/rails/show/HowtoInstallOnOSXTiger">ht=
tp://wiki.rubyonrails.com/rails/show/HowtoInstallOnOSXTiger</A>)<BR>
<HR>

<P>It May be as Simple as Passwords<BR>I tried the =E2=80=9Cquick fix =
suggestion=E2=80=9D=20
(listed a few posts above) by creating a user =E2=80=9Ctemp=E2=80=9D and =
it worked. I then went=20
back to look at my original user. It turned out that matching the =
passwords (or=20
lack thereof) for user(s), database(s), connection(s), and database.yml =
fixed=20
that user.</P>
<P>I happen to be using a <SPAN class=3Dcaps>GUI</SPAN> to interact with =
my <SPAN=20
class=3Dcaps>MYSQL</SPAN> databases and by simply removing my passwords =
from my=20
users, database connection, and database.yml I was able to get rid of =
the =E2=80=9Clost=20
connection=E2=80=9D and =E2=80=9Caccess denied for =
user=E2=80=A6=E2=80=9D errors.<BR>
<HR>

<P></P>
<P>If you=E2=80=99re on Windows you probably want to change =
=E2=80=98<CODE>localhost</CODE>=E2=80=99 to=20
<CODE>127.0.0.1</CODE> in your config file. If you specify=20
=E2=80=98<CODE>localhost</CODE>=E2=80=99 mysql client tries to connect =
via pipes, but <A=20
class=3DexistingWikiWord=20
href=3D"http://wiki.rubyonrails.org/rails/pages/MySQL">MySQL</A> server =
is usually=20
set up to connect via <SPAN class=3Dcaps>TCP</SPAN>/IP on Windows.</P>
<HR>
<BR>No joy changing =E2=80=9C<CODE>localhost</CODE>=E2=80=9D to =
=E2=80=9C<CODE>127.0.0.1</CODE>=E2=80=9D in=20
<CODE>database.yml</CODE> before starting WEBrick server. I get the same =
error=20
as before. Using Mac <SPAN class=3Dcaps>OS X 10</SPAN>.4.1 by the way.=20
<HR>
<BR>Just installed <A class=3DexistingWikiWord=20
href=3D"http://wiki.rubyonrails.org/rails/pages/MySQL">MySQL</A> =
Administrator for=20
Mac <SPAN class=3Dcaps>OS X</SPAN>, and noticed that the type for my =
tables is=20
=E2=80=9CMyISAM=E2=80=9D rather than =E2=80=9CInnoDB=E2=80=9D as I have =
seen in some examples. Could this be=20
making a difference? I didn=E2=80=99t specify the table type when I =
created the tables.=20
<HR>

<P>2errors). After compiling using gcc 3.3 everything was solved</P>
<P>I have Fedora Core 4, and can=E2=80=99t find any good information on =
`gcc_select`. Is=20
it a special <SPAN class=3Dcaps>OS X</SPAN> command, or can I find it =
somewhere=20
for my system? -Mike</P>
<P>I have posted a guide for fixing this on Fedora 4 (and hopefully =
other=20
similar distros) on Ruby Forums, here=E2=80=99s the <SPAN =
class=3Dcaps>URL</SPAN>: <A=20
href=3D"http://ocsforums.com/showthread.php?p=3D462">http://ocsforums.com=
/showthread.php?p=3D462</A></P>
<HR>

<BLOCKQUOTE>
  <P>I have the same problem.<BR>&gt;Including the same error as above =
when=20
  trying to install mysql &gt;extension via gem.<BR>&gt;I also tried to =
comment=20
  old_password in my.ini file and to create &gt;a new rails user, but it =
didn`t=20
  work.<BR>&gt;However, using my old user/password and commenting the =
line=20
  <BR>&gt;require =
=C3=A2=E2=82=AC=CB=9Cactive_record/vendor/mysql411=C3=A2=E2=82=AC=E2=84=A2=
 from mysql_adapter.rb=20
  &gt;worked for me.<BR>&gt;BTW: mysql 4.1.12 and =
windows.</P></BLOCKQUOTE>
<P>Yea, I tried reinstalling, didnt try the comment old_password, =
flushing,=20
following another tutorial and the only thing that worked was commenting =
out the=20
mysql411 line.</P><PRE><CODE>- vernon</CODE></PRE>
<HR>

<P>I=E2=80=99m using the <A class=3DexistingWikiWord=20
href=3D"http://wiki.rubyonrails.org/rails/pages/MySQL">MySQL</A> driver =
written in=20
ruby (active_record/vendor/mysql411.rb) on <SPAN class=3Dcaps>OS =
X</SPAN>. I was=20
seeing the same error as above while connecting:</P>
<P><EM>Access denied for user =
=E2=80=99=E2=80=99@=E2=80=99localhost=E2=80=99 (using password: =
NO)</EM></P>
<P>even though everything was specified in database.yml:</P>
<P>The apparent problem is that the driver was packing ints using native =
byte=20
order (=E2=80=98V=E2=80=99 and =E2=80=98v=E2=80=99) and even hard-coded =
little-endien (=E2=80=98L=E2=80=99). This was causing=20
the flags to get screwed up, creating the strange error (I suspect that =
a byte=20
order problem causes the same error in mysql-ruby-2.6.x). I fixed it by=20
replacing the packing directives with network byte order =
(=E2=80=98N=E2=80=99 and =E2=80=98n=E2=80=99):</P>diff=20
old_mysql411.rb new_mysql411.rb <BR>64c64<BR>&lt; @thread_id, =
@scramble_buff =3D=20
a.slice!(0,13).unpack(=E2=80=9CLa8=E2=80=9D)<BR>
<HR>
<BR>&gt; @thread_id, @scramble_buff =3D=20
a.slice!(0,13).unpack(=E2=80=9CNa8=E2=80=9D)<BR>66c66<BR>&lt; =
@server_capabilities, =3D=20
a.slice!(0,2).unpack(=E2=80=9Cv=E2=80=9D)<BR>
<HR>
<BR>&gt; @server_capabilities, =3D =
a.slice!(0,2).unpack(=E2=80=9Cn=E2=80=9D)<BR>69c69<BR>&lt;=20
@server_language, @server_status =3D a.unpack(=E2=80=9Ccv=E2=80=9D)<BR>
<HR>
<BR>&gt; @server_language, @server_status =3D =
a.unpack(=E2=80=9Ccn=E2=80=9D)<BR>112c112<BR>&lt;=20
template =3D =
=E2=80=9CVVcx23a#{user.size+1}cA#{password.size}a#{db.size+1}=E2=80=9D =
<BR>
<HR>
<BR>&gt; template =3D =
=E2=80=9CNNcx23a#{user.size+1}cA#{password.size}a#{db.size+1}=E2=80=9D=20
<BR>114c114<BR>&lt; template =3D =
=E2=80=9CVVcx23a#{user.size+1}cA#{password.size}x=E2=80=9D <BR>
<HR>
<BR>&gt; template =3D =
=E2=80=9CNNcx23a#{user.size+1}cA#{password.size}x=E2=80=9D=20
<P>=E2=80=94Sergei Gnezdov =E2=80=93 I follwed the instructions above =
(not mine) and they really=20
fix the problem as of September 20, 2005.<BR>
<HR>
<BR>The <A class=3DexistingWikiWord=20
href=3D"http://wiki.rubyonrails.org/rails/pages/ActiveRecord">ActiveRecor=
d</A>::StatementInvalid=20
error message can occur after the database drops the connection after an =

extended period of time and has been discussed on the forums <A=20
href=3D"http://wrath.rubyonrails.org/pipermail/rails/2005-February/002892=
.html">http://wrath.rubyonrails.org/pipermail/rails/2005-February/002892.=
html</A><BR>and=20
has been logged: <A=20
href=3D"http://dev.rubyonrails.com/ticket/428/">http://dev.rubyonrails.co=
m/ticket/428/</A>=20
<BR>
<HR>
<BR>If you are getting this error on some apps, but not others make sure =
that=20
your script/server has:
<P></P><CODE>#!/usr/bin/env ruby </CODE>
<P>and not</P><CODE>#!/usr/bin/ruby </CODE>
<P>I=E2=80=99m unsure why this works, but it worked for me. (on Mac =
<SPAN class=3Dcaps>OS=20
X </SPAN>Tiger)my</P>
<HR>

<P>I used to get the dreaded <STRONG>No database selected</STRONG> =
error,=20
compiling the 2.7 bindings from source solved this problem for me.</P>
<HR>

<P>I=E2=80=99ve got Cygwin, so I tried d/ling version 2.7 and compiling =
it myself, but=20
extconf.rb doesn=E2=80=99t even create the makefile! Any ideas? I might =
just end up=20
going back to postgres=E2=80=A6<BR>
<HR>
<BR>I=E2=80=99ve had the same problem with Windows/Mysql/Ruby=E2=80=A6I =
have figured it would be=20
difficult selling this to management when getting a basic driver to work =
is a=20
problem<BR>
<HR>

<P></P>
<P>If you used the MySQL.com installer on <SPAN class=3Dcaps>OS =
X</SPAN>, then the=20
location is /usr/local/mysql/bin, so the export line would =
be:<BR></P><PRE>export PATH=3D/usr/local/mysql/bin:$PATH
</PRE><BR></HR><BR>
<HR>
<BR>If you are getting:<BR><PRE>Access denied for user =
=E2=80=99root=E2=80=99@=E2=80=99localhost=E2=80=99 (using password: =
NO)</PRE><BR>then=20
try this advice from the friendly folks over at =
TextDrive:<BR><PRE>#!/bin/sh

killall -9 -u your_username lighttpd
killall -9 -u your_username ruby18
/usr/local/sbin/lighttpd -f /path/to/your/lighttpd.conf
</PRE>
<P></P>
<P>The =E2=80=9CRuby18=E2=80=9D may vary for you. It may be just =
=E2=80=9CRuby=E2=80=9D or for me it was=20
=E2=80=9D/usr/local/bin/ruby=E2=80=9D. You can use the following to find =
all the relevant=20
processes to kill:</P><PRE>ps axww | grep lighttpd
ps axww | grep ruby
</PRE>
<P>After trying every solution above multiple times and learning =
everything I=20
should have already known about MySQL, this is the solution that finally =
did it=20
for me. Rails simply wasn=E2=80=99t picking up any changes I had made to =
database.yml.=20
Solution originally posted here: <A=20
href=3D"http://forum.textdrive.com/viewtopic.php?pid=3D34869">http://foru=
m.textdrive.com/viewtopic.php?pid=3D34869</A></P>
<P>OR maybe you are like jonny and have a # at the beginning of your =
auto=20
generated password which has the effect of commenting out your =
password<BR>
<HR>

<P></P>
<P>Connecting to mysql on Dreamhost<STRONG></P>
<P>Just wanted to chime in that when connecting to mysql 4.1.11 from =
windows,=20
commenting the line<BR>require =
=E2=80=98active_record/vendor/mysql411=E2=80=99 from=20
mysql_adapter.rb worked for me.</P>
<HR>
Using:=20
<UL>
  <LI>Installed latest rails=20
  <LI>Installed Mysql5 from Mysql.com=20
  <LI>make sure mysql_config is in your <SPAN class=3Dcaps>PATH</SPAN> =
</LI></UL>
<HR>

<P></STRONG>This is another solution<STRONG><BR>I found a completely =
different=20
solution at <A class=3DexistingWikiWord=20
href=3D"http://wiki.rubyonrails.org/rails/pages/HowTosWorkerThreads">HowT=
osWorkerThreads</A></P>
<H4></STRONG>Confirmed* previous post for <SPAN =
class=3Dcaps>FC4</SPAN>.</H4>
<P>I am setting up Ruby on an <SPAN class=3Dcaps>FC4 </SPAN>Plesk 8=20
distro.<BR>When I previously attempted to test Ruby=E2=80=99s ability to =
communicate=20
with mySql 4.1 using the command</P><PRE>rake db:migrate
</PRE>
<P>I got the error message <BR><EM>Mysql::Error: Lost connection to =
MySQL server=20
during query:</EM></P>I installed these components via yum (yum install=20
mysql-devel, etc)=20
<UL>
  <LI>mysql-devel=20
  <LI>irb=20
  <LI>rdoc=20
  <LI>ruby-devel=20
  <LI>ruby-mysql gcc </LI></UL>
<P>Followed these additional steps, <BR></P><PRE>cd =
/usr/lib/ruby/gems/1.8/gems/mysql-2.7
sudo ruby extconf.rb --with-mysql-lib=3D/usr/lib/mysql
sudo gem install mysql
</PRE>
<P></P>
<P>Now it=E2=80=99s working brilliantly.</P>
<P>Thank you. <BR>(Paul Wolborsky @ ProjectHIRED.org</P>
<H4>Solution =E2=80=93 Windows XP.</H4>
<P>To avoid logging out of windows after modifing the Environmet =
Variable (PATH)=20
to add the path to =E2=80=9Cbin=E2=80=9D, try next:</P><PRE>set =
path=3D%path%;"C:\Program files\MySQL\MySQL Server 5.0\bin"=20
</PRE>
<P>Note: This will work just during the current windows session. The=20
modification of the environment variable is unavoidable.</P>
<P>Hello All<BR>I have set up ror on gentoo. The following is the error =
I get=20
trying to run my app:</P>
<P>uninitialized constant=20
ReleaserailController::User<BR>/usr/local/lib/ruby/gems/1.8/gems/activesu=
pport-1.4.4/lib/active_support/dependencies.rb:477:in=20
`const_missing=E2=80=99<BR>/usr/local/src/releaserail/app/controllers/rel=
easerail_controller.rb:9:in=20
`validate=E2=80=99</P>
<P>ReleaserailController is my app-controller wherein I create an object =
called=20
User by connecting to a db table called users</P>Any pointers why the =
object is=20
not getting created. Is it because my app is unable to connect to db? =
the=20
development-logs are of no help.<BR>
<HR>

<P>Hi,</P>
<P>I have been =E2=80=9Cfighting hard=E2=80=9D to connect to MySQL 5.0 =
from my rails app (the=20
depot app described in the pragmatic guide for RoR). I have configured =
MySQL=20
properly (as it is working fine from Command Line / MySQL =
Administrator), have=20
installed the latest gem for mysql, have also installed the <SPAN=20
class=3Dcaps>ODBC</SPAN> connector for rails.<BR>My database.yml is =
something like=20
this:<BR>development: adapter: mysql database: depot_development =
username: root=20
password: vaibhav host: localhost</P>
<P>However, when I try to access the web page using =E2=80=93 <A=20
href=3D"http://localhost:3000/admin">http://localhost:3000/admin</A> =
,<BR>I get=20
the following trace (sorry for pasting it here): Mysql::Error in=20
AdminController#index</P>
<H1>28000Access denied for user =
=E2=80=98root=E2=80=99@=E2=80=99localhost=E2=80=99 (using password: =
NO)</H1>
<P><SPAN class=3Dcaps>RAILS</SPAN>_ROOT: =
./script/../config/..<BR>Application=20
Trace | Framework Trace | Full Trace</P>
<P>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/v=
endor/mysql.rb:523:in=20
`read=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/=
active_record/vendor/mysql.rb:153:in=20
`real_connect=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1=
5.5/lib/active_record/connection_adapters/mysql_adapter.rb:389:in=20
`connect=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/l=
ib/active_record/connection_adapters/mysql_adapter.rb:152:in=20
`initialize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/connection_adapters/mysql_adapter.rb:82:in=20
`new=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/a=
ctive_record/connection_adapters/mysql_adapter.rb:82:in=20
`mysql_connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord=
-1.15.5/lib/active_record/connection_adapters/abstract/connection_specifi=
cation.rb:262:in=20
`send=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/=
active_record/connection_adapters/abstract/connection_specification.rb:26=
2:in=20
`connection_without_query_cache=3D=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/=
gems/activerecord-1.15.5/lib/active_record/query_cache.rb:54:in=20
`connection=3D=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.=
15.5/lib/active_record/connection_adapters/abstract/connection_specificat=
ion.rb:230:in=20
`retrieve_connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerec=
ord-1.15.5/lib/active_record/connection_adapters/abstract/connection_spec=
ification.rb:78:in=20
`connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/base.rb:763:in=20
`columns=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/l=
ib/active_record/calculations.rb:257:in=20
`column_for=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/calculations.rb:116:in=20
`calculate=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5=
/lib/active_record/calculations.rb:45:in=20
`count=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/a=
ction_controller/pagination.rb:179:in=20
`count_collection_for_pagination=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/ge=
ms/actionpack-1.13.5/lib/action_controller/pagination.rb:203:in=20
`paginator_and_collection_for=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/=
actionpack-1.13.5/lib/action_controller/pagination.rb:132:in=20
`paginate_without_deprecation=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/=
activesupport-1.4.4/lib/active_support/deprecation.rb:94:in=20
`paginate=E2=80=99<BR>C:/Documents and Settings/Me/My Documents/Aptana=20
Studio/depot/app/controllers/admin_controller.rb:12:in =
`list=E2=80=99<BR>C:/Documents=20
and Settings/Me/My Documents/Aptana=20
Studio/depot/app/controllers/admin_controller.rb:3:in =
`index=E2=80=99<BR>-e:4:in=20
`load=E2=80=99<BR>-e:4</P>
<P>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/v=
endor/mysql.rb:523:in=20
`read=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/=
active_record/vendor/mysql.rb:153:in=20
`real_connect=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1=
5.5/lib/active_record/connection_adapters/mysql_adapter.rb:389:in=20
`connect=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/l=
ib/active_record/connection_adapters/mysql_adapter.rb:152:in=20
`initialize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/connection_adapters/mysql_adapter.rb:82:in=20
`new=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/a=
ctive_record/connection_adapters/mysql_adapter.rb:82:in=20
`mysql_connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord=
-1.15.5/lib/active_record/connection_adapters/abstract/connection_specifi=
cation.rb:262:in=20
`send=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/=
active_record/connection_adapters/abstract/connection_specification.rb:26=
2:in=20
`connection_without_query_cache=3D=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/=
gems/activerecord-1.15.5/lib/active_record/query_cache.rb:54:in=20
`connection=3D=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.=
15.5/lib/active_record/connection_adapters/abstract/connection_specificat=
ion.rb:230:in=20
`retrieve_connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerec=
ord-1.15.5/lib/active_record/connection_adapters/abstract/connection_spec=
ification.rb:78:in=20
`connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/base.rb:763:in=20
`columns=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/l=
ib/active_record/calculations.rb:257:in=20
`column_for=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/calculations.rb:116:in=20
`calculate=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5=
/lib/active_record/calculations.rb:45:in=20
`count=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/a=
ction_controller/pagination.rb:179:in=20
`count_collection_for_pagination=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/ge=
ms/actionpack-1.13.5/lib/action_controller/pagination.rb:203:in=20
`paginator_and_collection_for=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/=
actionpack-1.13.5/lib/action_controller/pagination.rb:132:in=20
`paginate_without_deprecation=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/=
activesupport-1.4.4/lib/active_support/deprecation.rb:94:in=20
`paginate=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/li=
b/action_controller/base.rb:1101:in=20
`send=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ac=
tion_controller/base.rb:1101:in=20
`perform_action_without_filters=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gem=
s/actionpack-1.13.5/lib/action_controller/filters.rb:696:in=20
`call_filters=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.=
5/lib/action_controller/filters.rb:688:in=20
`perform_action_without_benchmark=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/g=
ems/actionpack-1.13.5/lib/action_controller/benchmarking.rb:66:in=20
`perform_action_without_rescue=E2=80=99<BR>c:/ruby/lib/ruby/1.8/benchmark=
.rb:293:in=20
`measure=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib=
/action_controller/benchmarking.rb:66:in=20
`perform_action_without_rescue=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems=
/actionpack-1.13.5/lib/action_controller/rescue.rb:83:in=20
`perform_action=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.1=
3.5/lib/action_controller/base.rb:435:in=20
`send=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ac=
tion_controller/base.rb:435:in=20
`process_without_filters=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actio=
npack-1.13.5/lib/action_controller/filters.rb:684:in=20
`process_without_session_management_support=E2=80=99<BR>c:/ruby/lib/ruby/=
gems/1.8/gems/actionpack-1.13.5/lib/action_controller/session_management.=
rb:114:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib=
/action_controller/base.rb:334:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/dispa=
tcher.rb:41:in=20
`dispatch=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/=
lib/mongrel/rails.rb:76:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/l=
ib/mongrel/rails.rb:74:in=20
`synchronize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin=
32/lib/mongrel/rails.rb:74:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/l=
ib/mongrel.rb:155:in=20
`process_client=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-ms=
win32/lib/mongrel.rb:154:in=20
`each=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/=
mongrel.rb:154:in=20
`process_client=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-ms=
win32/lib/mongrel.rb:281:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:281:in=20
`initialize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin3=
2/lib/mongrel.rb:281:in=20
`new=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:281:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:264:in=20
`initialize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin3=
2/lib/mongrel.rb:264:in=20
`new=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:264:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel/configurator.rb:282:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel/configurator.rb:281:in=20
`each=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/=
mongrel/configurator.rb:281:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/bin/m=
ongrel_rails:126:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel/command.rb:212:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/bin/m=
ongrel_rails:279<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/li=
b/active_support/dependencies.rb:488:in=20
`load=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/=
active_support/dependencies.rb:488:in=20
`load=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/=
active_support/dependencies.rb:342:in=20
`new_constants_in=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesuppor=
t-1.4.4/lib/active_support/dependencies.rb:488:in=20
`load=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/commands=
/servers/mongrel.rb:60<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_=
require.rb:27:in=20
`gem_original_require=E2=80=99<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems=
/custom_require.rb:27:in=20
`require=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/l=
ib/active_support/dependencies.rb:495:in=20
`require=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/l=
ib/active_support/dependencies.rb:342:in=20
`new_constants_in=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesuppor=
t-1.4.4/lib/active_support/dependencies.rb:495:in=20
`require=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/comma=
nds/server.rb:39<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_requir=
e.rb:27:in=20
`gem_original_require=E2=80=99<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems=
/custom_require.rb:27:in=20
`require=E2=80=99<BR>script/server:3</P>
<P>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/v=
endor/mysql.rb:523:in=20
`read=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/=
active_record/vendor/mysql.rb:153:in=20
`real_connect=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1=
5.5/lib/active_record/connection_adapters/mysql_adapter.rb:389:in=20
`connect=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/l=
ib/active_record/connection_adapters/mysql_adapter.rb:152:in=20
`initialize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/connection_adapters/mysql_adapter.rb:82:in=20
`new=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/a=
ctive_record/connection_adapters/mysql_adapter.rb:82:in=20
`mysql_connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord=
-1.15.5/lib/active_record/connection_adapters/abstract/connection_specifi=
cation.rb:262:in=20
`send=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/=
active_record/connection_adapters/abstract/connection_specification.rb:26=
2:in=20
`connection_without_query_cache=3D=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/=
gems/activerecord-1.15.5/lib/active_record/query_cache.rb:54:in=20
`connection=3D=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.=
15.5/lib/active_record/connection_adapters/abstract/connection_specificat=
ion.rb:230:in=20
`retrieve_connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerec=
ord-1.15.5/lib/active_record/connection_adapters/abstract/connection_spec=
ification.rb:78:in=20
`connection=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/base.rb:763:in=20
`columns=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/l=
ib/active_record/calculations.rb:257:in=20
`column_for=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.=
5/lib/active_record/calculations.rb:116:in=20
`calculate=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5=
/lib/active_record/calculations.rb:45:in=20
`count=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/a=
ction_controller/pagination.rb:179:in=20
`count_collection_for_pagination=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/ge=
ms/actionpack-1.13.5/lib/action_controller/pagination.rb:203:in=20
`paginator_and_collection_for=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/=
actionpack-1.13.5/lib/action_controller/pagination.rb:132:in=20
`paginate_without_deprecation=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/=
activesupport-1.4.4/lib/active_support/deprecation.rb:94:in=20
`paginate=E2=80=99<BR>C:/Documents and Settings/Me/My Documents/Aptana=20
Studio/depot/app/controllers/admin_controller.rb:12:in =
`list=E2=80=99<BR>C:/Documents=20
and Settings/Me/My Documents/Aptana=20
Studio/depot/app/controllers/admin_controller.rb:3:in=20
`index=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/a=
ction_controller/base.rb:1101:in=20
`send=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ac=
tion_controller/base.rb:1101:in=20
`perform_action_without_filters=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gem=
s/actionpack-1.13.5/lib/action_controller/filters.rb:696:in=20
`call_filters=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.=
5/lib/action_controller/filters.rb:688:in=20
`perform_action_without_benchmark=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/g=
ems/actionpack-1.13.5/lib/action_controller/benchmarking.rb:66:in=20
`perform_action_without_rescue=E2=80=99<BR>c:/ruby/lib/ruby/1.8/benchmark=
.rb:293:in=20
`measure=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib=
/action_controller/benchmarking.rb:66:in=20
`perform_action_without_rescue=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems=
/actionpack-1.13.5/lib/action_controller/rescue.rb:83:in=20
`perform_action=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.1=
3.5/lib/action_controller/base.rb:435:in=20
`send=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ac=
tion_controller/base.rb:435:in=20
`process_without_filters=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actio=
npack-1.13.5/lib/action_controller/filters.rb:684:in=20
`process_without_session_management_support=E2=80=99<BR>c:/ruby/lib/ruby/=
gems/1.8/gems/actionpack-1.13.5/lib/action_controller/session_management.=
rb:114:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib=
/action_controller/base.rb:334:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/dispa=
tcher.rb:41:in=20
`dispatch=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/=
lib/mongrel/rails.rb:76:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/l=
ib/mongrel/rails.rb:74:in=20
`synchronize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin=
32/lib/mongrel/rails.rb:74:in=20
`process=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/l=
ib/mongrel.rb:155:in=20
`process_client=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-ms=
win32/lib/mongrel.rb:154:in=20
`each=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/=
mongrel.rb:154:in=20
`process_client=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-ms=
win32/lib/mongrel.rb:281:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:281:in=20
`initialize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin3=
2/lib/mongrel.rb:281:in=20
`new=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:281:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:264:in=20
`initialize=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin3=
2/lib/mongrel.rb:264:in=20
`new=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel.rb:264:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel/configurator.rb:282:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel/configurator.rb:281:in=20
`each=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/=
mongrel/configurator.rb:281:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/bin/m=
ongrel_rails:126:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/lib/m=
ongrel/command.rb:212:in=20
`run=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1-mswin32/bin/m=
ongrel_rails:279<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/li=
b/active_support/dependencies.rb:488:in=20
`load=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/=
active_support/dependencies.rb:488:in=20
`load=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/=
active_support/dependencies.rb:342:in=20
`new_constants_in=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesuppor=
t-1.4.4/lib/active_support/dependencies.rb:488:in=20
`load=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/commands=
/servers/mongrel.rb:60<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_=
require.rb:27:in=20
`gem_original_require=E2=80=99<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems=
/custom_require.rb:27:in=20
`require=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/l=
ib/active_support/dependencies.rb:495:in=20
`require=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.4.4/l=
ib/active_support/dependencies.rb:342:in=20
`new_constants_in=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/activesuppor=
t-1.4.4/lib/active_support/dependencies.rb:495:in=20
`require=E2=80=99<BR>c:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/comma=
nds/server.rb:39<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_requir=
e.rb:27:in=20
`gem_original_require=E2=80=99<BR>c:/ruby/lib/ruby/site_ruby/1.8/rubygems=
/custom_require.rb:27:in=20
`require=E2=80=99<BR>script/server:3<BR>-e:4:in =
`load=E2=80=99<BR>-e:4</P>
<P>Can anyone suggest a solution?<BR>Thanks so =
much,<BR>=E2=80=94Vaibhav</P>
<HR>
<BR>Did some tweaking and it worked! The problem was, that despite =
granting all=20
previliges, it was not taking previliges for the schema objects (donnow =
why). I=20
used the MySQL Administrator to grant all sort of prviliges to the root =
admin=20
and now it works fine.<BR>=E2=80=94Vaibhav=20
<P>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</P>=

<P>I am running Mac <SPAN class=3Dcaps>OS X </SPAN>(10.5.2 Leopard) =
using=20
bash.</P>
<P>I keep on getting this error when I try to migrate using mysql. The=20
installation of the mysql 2.7 gem went smoothly.</P>
<P>sh-3.2# rake db:migrate<BR>(in /company)<BR>rake =
aborted!<BR>Mysql::Error:=20
Can=E2=80=99t create/write to file=20
=E2=80=99/var/folders/4l/4lwPySMtG6OHKjCXPptBlE+++TI/<DEL>Tmp</DEL>/#sql_=
430_0.MYI=E2=80=99=20
(Errcode: 13): <SPAN class=3Dcaps>SHOW FIELDS FROM =
</SPAN>`employees`</P>
<P>(See full trace by running task with=E2=80=94trace)</P>
<P>If anyone has any pointers,=20
please.<BR><DEL>Joe<BR>=3D</DEL>=3D<DEL>=3D</DEL>=3D<DEL>=3D</DEL>=3D<DEL=
>=3D</DEL>=3D<DEL>=3D</DEL>=3D<DEL>=3D</DEL>=3D<DEL>=3D</DEL>=3D<DEL>=3D<=
/DEL>=3D<DEL>=3D</DEL>=3D<DEL>=3D</DEL>=3D<DEL>=3D</DEL>=3D<DEL>=3D</DEL>=
=3D</P>
<DIV class=3Dbyline>Updated on March 21, 2008 05:41 by <A=20
href=3D"http://wiki.rubyonrails.org/rails/pages/jonny">jonny</A> =
(68.13.137.165)=20
</DIV>
<DIV class=3Dnavigation><A=20
href=3D"http://wiki.rubyonrails.org/rails/pages/mysql+database+access+pro=
blem/versions/new">Edit</A>=20
| <A class=3Dnavlink=20
href=3D"http://wiki.rubyonrails.org/rails/pages/MySQL+Database+access+pro=
blem/versions/229">Back=20
in time</A> <SMALL>(229 older versions)</SMALL> </DIV>
<DIV id=3Dfooter>
<P><A href=3D"http://instiki.org/">i2</A> on <A=20
href=3D"http://rubyonrails.com/">Rails</A></P></DIV></DIV></DIV></BODY></=
HTML>

------=_NextPart_000_0000_01C8ADD6.156E35D0
Content-Type: application/octet-stream
Content-Transfer-Encoding: base64
Content-Location: http://wiki.rubyonrails.org/images/favicon.png?1171099937

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAWElEQVQ4jWNkgIJVckz/GcgAjJRo
ZmBgYGDEpTnkwR+sGtYosKDwmUjRjA2woAuga0a3ER1gdQGxmgkaQAwYNWBYGIAzLxADwh79YyTb
BWGP/jEyMDAwAABt+xSx5rzG8gAAAABJRU5ErkJggg==

------=_NextPart_000_0000_01C8ADD6.156E35D0
Content-Type: application/octet-stream
Content-Transfer-Encoding: quoted-printable
Content-Location: http://wiki.rubyonrails.org/stylesheets/instiki.css?1171099937

BODY {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BACKGROUND: =
url(/images/topbluefade.gif) #fff repeat-x; PADDING-BOTTOM: 0px; MARGIN: =
10px 0px 0px; PADDING-TOP: 0px; TEXT-ALIGN: center
}
BODY {
	COLOR: #333; FONT-FAMILY: verdana, "Lucida Grande", arial, helvetica, =
sans-serif
}
P {
	COLOR: #333; FONT-FAMILY: verdana, "Lucida Grande", arial, helvetica, =
sans-serif
}
OL {
	COLOR: #333; FONT-FAMILY: verdana, "Lucida Grande", arial, helvetica, =
sans-serif
}
UL {
	COLOR: #333; FONT-FAMILY: verdana, "Lucida Grande", arial, helvetica, =
sans-serif
}
TD {
	COLOR: #333; FONT-FAMILY: verdana, "Lucida Grande", arial, helvetica, =
sans-serif
}
#Container {
	FLOAT: none; MARGIN: 0px auto; TEXT-ALIGN: center
}
#Content {
	PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FLOAT: left; PADDING-BOTTOM: =
5px; MARGIN: 0px; BORDER-TOP-STYLE: none; PADDING-TOP: 5px; TEXT-ALIGN: =
left
}
DIV#Header {
	MARGIN: 15px 0px 10px; TEXT-ALIGN: center
}
DIV#Header IMG {
	FLOAT: right; MARGIN: 0px; VERTICAL-ALIGN: middle; BORDER-TOP-STYLE: =
none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; =
BORDER-BOTTOM-STYLE: none
}
DIV#Header DIV#Nav IMG {
	FLOAT: none; MARGIN-RIGHT: 5px
}
DIV#Header DIV#Nav {
	FONT-SIZE: 10px; COLOR: #999
}
DIV#Header DIV#Nav A:link {
	FONT-WEIGHT: bold; FONT-SIZE: 11px; COLOR: #000
}
DIV#Header DIV#Nav A:visited {
	FONT-WEIGHT: bold; FONT-SIZE: 11px; COLOR: #000
}
DIV#Header DIV#Nav A:hover {
	BACKGROUND: #333; COLOR: #fff
}
DIV#Header DIV.clearall {
	CLEAR: both; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 2px; =
PADDING-BOTTOM: 0px; MARGIN: 0px 0px 20px; PADDING-TOP: 0px
}
A {
	COLOR: #369
}
A:visited {
	COLOR: #369
}
A:hover {
	BACKGROUND-COLOR: #f4dda6
}
.newWikiWord {
	BACKGROUND-COLOR: #eee
}
.newWikiWord A:hover {
	BACKGROUND-COLOR: white
}
H1 {
	COLOR: #333; FONT-FAMILY: georgia, verdana, sans-serif
}
H2 {
	COLOR: #333; FONT-FAMILY: georgia, verdana, sans-serif
}
H3 {
	COLOR: #333; FONT-FAMILY: georgia, verdana, sans-serif
}
H1 {
	FONT-SIZE: 28px
}
H2 {
	FONT-SIZE: 19px
}
H3 {
	FONT-SIZE: 16px
}
H1#pageName {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 5px =
0px 0px; COLOR: #000; LINE-HEIGHT: 28px; PADDING-TOP: 0px; POSITION: =
relative
}
H1#pageName SMALL {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; LEFT: 0px; =
PADDING-BOTTOM: 0px; COLOR: #444; LINE-HEIGHT: 10px; PADDING-TOP: 0px; =
POSITION: absolute; TOP: -15px
}
H1#pageName BR {
	DISPLAY: none
}
#i2Nav {
	MARGIN: 40px 0px 15px
}
* HTML #i2Nav {
	HEIGHT: 112px
}
A.nav {
	COLOR: #000
}
A.nav:link {
	COLOR: #000
}
A.nav:visited {
	COLOR: #000
}
A.nav:hover {
	COLOR: #fff; BACKGROUND-COLOR: #000
}
LI {
	MARGIN-BOTTOM: 7px
}
.navigation {
	MARGIN-TOP: 5px; FONT-SIZE: 12px; COLOR: #999
}
.navigation A:hover {
	COLOR: #fff; BACKGROUND-COLOR: #000
}
.navigation A {
	FONT-WEIGHT: bold; FONT-SIZE: 11px; COLOR: black
}
.navigation SMALL A {
	FONT-WEIGHT: normal; FONT-SIZE: 11px
}
.navOn {
	FONT-WEIGHT: bold; FONT-SIZE: 11px; COLOR: #444; TEXT-DECORATION: none
}
.help {
	FONT-SIZE: 11px; FONT-FAMILY: verdana, arial, helvetica, sans-serif
}
.inputBox {
	PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-SIZE: 11px; MARGIN-BOTTOM: =
20px; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: verdana, =
arial, helvetica, sans-serif; BACKGROUND-COLOR: #eee
}
BLOCKQUOTE {
	PADDING-RIGHT: 30px; DISPLAY: block; PADDING-LEFT: 30px; FONT-SIZE: =
11px; PADDING-BOTTOM: 0px; MARGIN: 0px 0px 20px; LINE-HEIGHT: 17px; =
PADDING-TOP: 0px; FONT-STYLE: italic
}
PRE {
	PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 11px; =
PADDING-BOTTOM: 10px; OVERFLOW: auto; PADDING-TOP: 10px; =
BACKGROUND-COLOR: #eee
}
OL.setup {
	PADDING-LEFT: 25px; FONT-SIZE: 19px; FONT-FAMILY: georgia, verdana, =
sans-serif
}
OL.setup LI {
	MARGIN-BOTTOM: 20px
}
.byline {
	FONT-SIZE: 10px; MARGIN-BOTTOM: 10px; COLOR: #999; FONT-STYLE: italic
}
.references {
	FONT-SIZE: 10px
}
.diffdel {
	BACKGROUND: pink
}
DEL.diffmod {
	BACKGROUND: pink
}
.diffins {
	BACKGROUND: lightgreen
}
INS.diffmod {
	BACKGROUND: lightgreen
}
#footer {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0.25em; =
PADDING-TOP: 0.25em; HEIGHT: 14px
}
#footer P {
	FONT-SIZE: 10px; FLOAT: right; MARGIN: 0px; COLOR: gray; FONT-STYLE: =
italic; TEXT-ALIGN: right
}
#error {
	WIDTH: 600px; COLOR: #8b0000; FONT-STYLE: italic
}
#info {
	WIDTH: 600px; COLOR: #006400; FONT-STYLE: italic
}
#TextileHelp TABLE {
	MARGIN-BOTTOM: 0px
}
#TextileHelp TABLE + H3 {
	MARGIN-TOP: 11px
}
#TextileHelp TABLE TD {
	PADDING-RIGHT: 3px; BORDER-TOP: #ccc 1px dotted; PADDING-LEFT: 3px; =
FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: top; PADDING-TOP: =
3px
}
#TextileHelp TABLE TD.arrow {
	PADDING-RIGHT: 5px; PADDING-LEFT: 10px; COLOR: #999
}
#TextileHelp TABLE TD.label {
	PADDING-RIGHT: 15px; FONT-WEIGHT: bold; FONT-SIZE: 10px; COLOR: #000; =
WHITE-SPACE: nowrap
}
#TextileHelp H3 {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; FONT-SIZE: =
11px; PADDING-BOTTOM: 0px; MARGIN: 0px 0px 5px; PADDING-TOP: 5px
}
#TextileHelp P {
	FONT-SIZE: 10px
}
#editForm {
	FLOAT: left; MARGIN-RIGHT: -255px
}
#version_body {
	WIDTH: 400px; HEIGHT: 500px
}
#MarkupHelp {
	MARGIN-TOP: 5px; FONT-SIZE: 12px; FLOAT: right; WIDTH: 250px
}
.newsList {
	MARGIN-TOP: 20px
}
.newsList P {
	MARGIN-BOTTOM: 30px
}
TD {
=09
}
TABLE {
	BORDER-LEFT-COLOR: black; BORDER-BOTTOM-COLOR: black; BORDER-TOP-STYLE: =
double; BORDER-TOP-COLOR: black; BORDER-RIGHT-STYLE: double; =
BORDER-LEFT-STYLE: double; BORDER-COLLAPSE: collapse; =
BORDER-RIGHT-COLOR: black; BORDER-BOTTOM-STYLE: double
}
.byline {
	PADDING-TOP: 15px
}
.property {
	FONT-SIZE: 10px
}
.c:unknown {
	CLEAR: both; DISPLAY: block; VISIBILITY: hidden; HEIGHT: 0px; content: =
"."
}
.c {
=09
}
* HTML .c {
	HEIGHT: 1%
}
.c {
	DISPLAY: block
}

------=_NextPart_000_0000_01C8ADD6.156E35D0
Content-Type: application/octet-stream
Content-Transfer-Encoding: quoted-printable
Content-Location: http://wiki.rubyonrails.org/stylesheets/captcha.css?1171099937

#brain_buster_captcha {
	DISPLAY: block; FONT-SIZE: 12px
}
#brain_buster_captcha INPUT#captcha_answer {
=09
}
.captcha_failed#brain_buster_captcha LABEL {
	PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING-BOTTOM: 1px; =
PADDING-TOP: 1px; BACKGROUND-COLOR: #ffff99
}
#captcha_credit {
	PADDING-RIGHT: 0px; DISPLAY: block; PADDING-LEFT: 0px; FONT-SIZE: 10px; =
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px
}

------=_NextPart_000_0000_01C8ADD6.156E35D0--
